local sqlite3 = require("lsqlite3")
--sqlite3 = require "luasql.sqlite3"
local conn  = sqlite3.open("D:/_life/sqlite/bdc.db")

--local conn = env:connect('mydb.sqlite')
--print(env,conn)

status,errorString = conn:execute([[CREATE TABLE sample ('id' INTEGER, 'name' TEXT)]])
--print(status,errorString )

 for a in conn:nrows('SELECT * FROM test') do 
   for k,v in pairs(a) do
     print(k,v)
   end
  end